Get Table Range
AutomatR.Excel.Activities.GetTableRange
The "Get Table Range" activity in AutomatR is part of the Excel Table activities package, designed to extract the range of an Excel table from a specified spreadsheet. This activity is useful for dynamically working with the data within a named Excel table, enhancing automation workflows.
Properties
| Name | Description |
|---|---|
| Input | |
| Table Name | Specifies the name of the Excel table from which to extract the range. String variables containing the table name. |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Get Table Range" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
| Output | |
| Result | Returns the string representing the range of the Excel table (e.g., "A1:B5"). String variables containing the range value. |
How to use:
- Drag and drop the "Get Table Range" activity onto the workflow.
- Configure the properties by specifying the table name.
- Optionally, configure the delay.
- Execute the workflow to retrieve the range of the specified Excel table.
Example: Consider an example where the "Get Table Range" activity is used to extract the range of an Excel table named "EmployeeData":
Get Table Range:
Delay: 2
Table Name: "EmployeeData"
Result: tableRange
In this example, the activity retrieves the range of the "EmployeeData" Excel table, and the range value is stored in the string variable "tableRange" for further processing in the workflow.
Note: Ensure that the "Get Table Range" activity is placed within an "Excel Root" activity to establish the Excel context for execution.